﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ServiceOrderPull" targetNamespace="http://tempuri.org/ServiceOrderPull.xsd" xmlns:mstns="http://tempuri.org/ServiceOrderPull.xsd" xmlns="http://tempuri.org/ServiceOrderPull.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ACC_NEW" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ACC_NEW (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ACC_NEW.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ORDERS_VIEWTableAdapter" GeneratorDataComponentClassName="ORDERS_VIEWTableAdapter" Name="ORDERS_VIEW" UserDataComponentName="ORDERS_VIEWTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ACC_NEW (Web.config)" DbObjectName="dbo.ORDERS_VIEW" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     START_DT, REGION, MARKET, ACCT_MGR, PRODUCT, FEATURE, NATIONAL_ID, PROGRAM, DIRECTION, SALES_CHANNEL, ORDER_ID, BAN, 
                      WIRE_CENTER, DA_CD, TRAC_ID, LUID, ELU_ID, PROPERTY_NM
FROM         ORDERS_VIEW</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="START_DT" DataSetColumn="START_DT" />
              <Mapping SourceColumn="REGION" DataSetColumn="REGION" />
              <Mapping SourceColumn="MARKET" DataSetColumn="MARKET" />
              <Mapping SourceColumn="ACCT_MGR" DataSetColumn="ACCT_MGR" />
              <Mapping SourceColumn="PRODUCT" DataSetColumn="PRODUCT" />
              <Mapping SourceColumn="FEATURE" DataSetColumn="FEATURE" />
              <Mapping SourceColumn="NATIONAL_ID" DataSetColumn="NATIONAL_ID" />
              <Mapping SourceColumn="PROGRAM" DataSetColumn="PROGRAM" />
              <Mapping SourceColumn="DIRECTION" DataSetColumn="DIRECTION" />
              <Mapping SourceColumn="SALES_CHANNEL" DataSetColumn="SALES_CHANNEL" />
              <Mapping SourceColumn="ORDER_ID" DataSetColumn="ORDER_ID" />
              <Mapping SourceColumn="BAN" DataSetColumn="BAN" />
              <Mapping SourceColumn="WIRE_CENTER" DataSetColumn="WIRE_CENTER" />
              <Mapping SourceColumn="DA_CD" DataSetColumn="DA_CD" />
              <Mapping SourceColumn="TRAC_ID" DataSetColumn="TRAC_ID" />
              <Mapping SourceColumn="LUID" DataSetColumn="LUID" />
              <Mapping SourceColumn="ELU_ID" DataSetColumn="ELU_ID" />
              <Mapping SourceColumn="PROPERTY_NM" DataSetColumn="PROPERTY_NM" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ServiceOrderPull" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="False" msprop:Generator_DataSetName="ServiceOrderPull" msprop:Generator_UserDSName="ServiceOrderPull">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ORDERS_VIEW" msprop:Generator_TableClassName="ORDERS_VIEWDataTable" msprop:Generator_TableVarName="tableORDERS_VIEW" msprop:Generator_TablePropName="ORDERS_VIEW" msprop:Generator_RowDeletingName="ORDERS_VIEWRowDeleting" msprop:Generator_UserTableName="ORDERS_VIEW" msprop:Generator_RowChangingName="ORDERS_VIEWRowChanging" msprop:Generator_RowEvHandlerName="ORDERS_VIEWRowChangeEventHandler" msprop:Generator_RowDeletedName="ORDERS_VIEWRowDeleted" msprop:Generator_RowEvArgName="ORDERS_VIEWRowChangeEvent" msprop:Generator_RowChangedName="ORDERS_VIEWRowChanged" msprop:Generator_RowClassName="ORDERS_VIEWRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="START_DT" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnSTART_DT" msprop:Generator_ColumnPropNameInRow="START_DT" msprop:Generator_ColumnPropNameInTable="START_DTColumn" msprop:Generator_UserColumnName="START_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="REGION" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnREGION" msprop:Generator_ColumnPropNameInRow="REGION" msprop:Generator_ColumnPropNameInTable="REGIONColumn" msprop:Generator_UserColumnName="REGION" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MARKET" msprop:Generator_ColumnVarNameInTable="columnMARKET" msprop:Generator_ColumnPropNameInRow="MARKET" msprop:Generator_ColumnPropNameInTable="MARKETColumn" msprop:Generator_UserColumnName="MARKET" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACCT_MGR" msprop:Generator_ColumnVarNameInTable="columnACCT_MGR" msprop:Generator_ColumnPropNameInRow="ACCT_MGR" msprop:Generator_ColumnPropNameInTable="ACCT_MGRColumn" msprop:Generator_UserColumnName="ACCT_MGR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRODUCT" msprop:Generator_ColumnVarNameInTable="columnPRODUCT" msprop:Generator_ColumnPropNameInRow="PRODUCT" msprop:Generator_ColumnPropNameInTable="PRODUCTColumn" msprop:Generator_UserColumnName="PRODUCT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FEATURE" msprop:Generator_ColumnVarNameInTable="columnFEATURE" msprop:Generator_ColumnPropNameInRow="FEATURE" msprop:Generator_ColumnPropNameInTable="FEATUREColumn" msprop:Generator_UserColumnName="FEATURE">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NATIONAL_ID" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNATIONAL_ID" msprop:Generator_ColumnPropNameInRow="NATIONAL_ID" msprop:Generator_ColumnPropNameInTable="NATIONAL_IDColumn" msprop:Generator_UserColumnName="NATIONAL_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PROGRAM" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPROGRAM" msprop:Generator_ColumnPropNameInRow="PROGRAM" msprop:Generator_ColumnPropNameInTable="PROGRAMColumn" msprop:Generator_UserColumnName="PROGRAM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DIRECTION" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDIRECTION" msprop:Generator_ColumnPropNameInRow="DIRECTION" msprop:Generator_ColumnPropNameInTable="DIRECTIONColumn" msprop:Generator_UserColumnName="DIRECTION" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SALES_CHANNEL" msprop:Generator_ColumnVarNameInTable="columnSALES_CHANNEL" msprop:Generator_ColumnPropNameInRow="SALES_CHANNEL" msprop:Generator_ColumnPropNameInTable="SALES_CHANNELColumn" msprop:Generator_UserColumnName="SALES_CHANNEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_ID" msprop:Generator_ColumnVarNameInTable="columnORDER_ID" msprop:Generator_ColumnPropNameInRow="ORDER_ID" msprop:Generator_ColumnPropNameInTable="ORDER_IDColumn" msprop:Generator_UserColumnName="ORDER_ID" type="xs:int" minOccurs="0" />
              <xs:element name="BAN" msprop:Generator_ColumnVarNameInTable="columnBAN" msprop:Generator_ColumnPropNameInRow="BAN" msprop:Generator_ColumnPropNameInTable="BANColumn" msprop:Generator_UserColumnName="BAN" type="xs:int" minOccurs="0" />
              <xs:element name="WIRE_CENTER" msprop:Generator_ColumnVarNameInTable="columnWIRE_CENTER" msprop:Generator_ColumnPropNameInRow="WIRE_CENTER" msprop:Generator_ColumnPropNameInTable="WIRE_CENTERColumn" msprop:Generator_UserColumnName="WIRE_CENTER" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DA_CD" msprop:Generator_ColumnVarNameInTable="columnDA_CD" msprop:Generator_ColumnPropNameInRow="DA_CD" msprop:Generator_ColumnPropNameInTable="DA_CDColumn" msprop:Generator_UserColumnName="DA_CD" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRAC_ID" msprop:Generator_ColumnVarNameInTable="columnTRAC_ID" msprop:Generator_ColumnPropNameInRow="TRAC_ID" msprop:Generator_ColumnPropNameInTable="TRAC_IDColumn" msprop:Generator_UserColumnName="TRAC_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LUID" msprop:Generator_ColumnVarNameInTable="columnLUID" msprop:Generator_ColumnPropNameInRow="LUID" msprop:Generator_ColumnPropNameInTable="LUIDColumn" msprop:Generator_UserColumnName="LUID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ELU_ID" msprop:Generator_ColumnVarNameInTable="columnELU_ID" msprop:Generator_ColumnPropNameInRow="ELU_ID" msprop:Generator_ColumnPropNameInTable="ELU_IDColumn" msprop:Generator_UserColumnName="ELU_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PROPERTY_NM" msprop:Generator_ColumnVarNameInTable="columnPROPERTY_NM" msprop:Generator_ColumnPropNameInRow="PROPERTY_NM" msprop:Generator_ColumnPropNameInTable="PROPERTY_NMColumn" msprop:Generator_UserColumnName="PROPERTY_NM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>